package com.myteam.mystory.DAO;

import android.database.sqlite.SQLiteDatabase;

public class ChapterScheme {
	public static final String TABLE_CHAPTER_NAME = "chapter";
	public static final String STORYID = "storyid";
	public static final String CHAPTERNAME = "chaptername";
	public static final String CHAPTERCONTENT = "chaptercontent";
	public static final String IMGLINK = "inglink";
	public static final String SYNCDATE = "syncdate";
	public static final String HISTORY = "history";
	public static final String BOOKMARK = "bookmark";
	public static final String STATUT = "statut";

	private static final String DATEBASE_CREATE_CHAPTER = "create table "
			+ TABLE_CHAPTER_NAME + "(" + STORYID + " text primary key, "
			+ CHAPTERNAME + " text not null, " + CHAPTERCONTENT
			+ " text not null, " + IMGLINK + " text not null, " + SYNCDATE
			+ " text not null, " + HISTORY + " interger not null, " + BOOKMARK
			+ " interger not null, " + STATUT + " text not null)";
	
	public static void onCreate(SQLiteDatabase db){
		db.execSQL(DATEBASE_CREATE_CHAPTER);
	}
}
